SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267376 LIMIT 1 [ RunTime:0.001239s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267376 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626495,884060,211092,1040737,915565,248951,723325,938169,280859,169109,402088,113860,259588,673625,831361,10458,952978,93236,109060,343024,858720,780734,452645,279509,396067,797435,880495,82972,973808,741580,81613,18229,246480,936815,994817,218970,898997,50172,568460,1039203,723997,700152,447699,375806,362246,952424,402444,337468,74342,166162,277264,347562,581483,848201,553788,1046508,179195,307444,34748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]