SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001703s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802914 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802914 [ RunTime:0.004233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546041,526783,447207,1028689,858642,132522,617350,559941,93839,926006,453247,1006927,369749,311910,24848,816966,246496,592735,166403,574442,1046961,706316,984433,206571,119090,113309,590730,13905,912762,313276,334999,482088,533401,976071,1007307,630228,900235,455297,558990,867240,325713,183440,932445,386232,1014425,507016,115914,606673,693386,183365,147157,587717,945630,974448,114677,143288,862368,138310,663187,847128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]