SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340176 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340176 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014928,277774,490742,577556,493486,887763,86264,917589,453471,65619,482966,590272,1047224,497643,908049,675868,561355,880705,920713,109915,665004,883669,28092,53350,576490,532952,974379,684048,870979,1038200,430639,722212,869513,619951,198493,1035765,662572,3859,502182,57922,959962,517030,745514,316791,655343,996291,853418,255324,700369,814585,329740,24824,693096,635495,91097,436947,395539,113761,1031091,273625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]