SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507916 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507916 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546290,652998,866137,172186,74678,636574,385640,800379,298793,964021,985467,760896,69713,1026425,405292,128235,216597,717776,245723,1035620,185927,681807,843066,504084,459709,569692,344473,579199,208785,635605,852275,283008,1024488,623872,812821,331478,231364,811378,333057,515578,544354,1039975,92518,3692,911630,432255,1025068,815266,736353,647838,53181,546888,478626,601289,927597,184009,436614,424507,785883,629047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]