SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42523 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42523 [ RunTime:0.003434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431798,705536,1017323,67459,38584,560590,924472,345878,206854,687227,864,40870,808528,785529,252646,319306,574966,737298,209842,1037754,445783,467714,27818,106166,907960,519254,695574,357214,143626,1012360,481366,1021390,543149,28836,151268,326634,83864,254013,167137,278510,322239,506278,735638,1010672,526360,467676,534231,343312,259011,895174,587363,886007,193302,23648,413354,747675,920453,340503,814161,323085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]