SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252008 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252008 [ RunTime:0.004009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552044,543707,99462,296654,800672,19143,710605,680066,225272,84733,581294,1041704,646580,782986,81963,632849,210732,671721,999731,745141,407707,103166,648258,708062,259506,497242,992089,469534,889222,949268,675466,647795,613445,129815,163054,18681,741329,411621,856362,818748,250568,685619,591942,723581,713982,129650,69175,190126,949770,801690,272904,762872,691266,254966,10719,422535,139096,101366,21079,20737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]