SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101874 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101874 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324239,711443,203947,959047,1045960,174994,941571,938079,919572,494777,73395,124835,503408,683877,115016,92320,333569,487209,930018,203809,836239,237243,300966,1025558,284209,1042286,45100,140065,940966,614480,740082,994276,1008728,496592,506882,212521,943702,20985,951172,1047463,173155,310924,520482,570076,789553,858712,803612,410844,358151,148099,1037293,148386,824323,955037,218200,1003526,612723,843887,917033,479576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]