SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562760 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562760 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47959,824035,1037210,172531,244746,302580,805012,974759,925982,932628,24911,439271,414128,481155,1040113,941640,857434,421509,509226,222499,825757,903099,536614,169736,263726,495089,14147,271618,1009471,147234,358399,1034874,848160,792870,185854,656616,863990,202876,36459,384195,52156,511210,210271,930871,674343,876062,68945,175948,570146,220634,493643,114825,490813,484940,614307,252245,195842,581903,456192,1016956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]