SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54785 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54785 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402464,668889,171805,363718,327456,530590,481976,451348,131863,466917,217513,344437,916340,571970,884458,868193,996461,54051,962583,283601,39962,373460,453130,185991,214695,797885,522714,847271,85679,49814,587134,142424,925909,305234,4142,837763,32767,366101,249541,428792,35709,1013851,410288,610175,778183,409591,23980,935368,84147,1011273,342660,66968,776647,752995,596875,247069,341417,531760,354800,588517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]