SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333986 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333986 [ RunTime:0.002691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020126,854981,464879,795612,748467,687294,102063,653549,851296,7063,104389,646817,813454,294212,54494,237372,119492,17323,32572,206094,460645,795675,926690,582436,31537,312704,1014249,441748,248360,841764,508604,746668,118975,1034038,349389,66939,607529,603200,252688,231914,988540,1039697,676826,589048,760074,184472,242060,1007767,527815,378512,958167,838860,18231,404270,721855,257816,317831,847055,666482,752259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]