SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10144 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10144 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019658,400188,947403,236453,76373,768601,442228,642014,72119,810622,981073,227444,445351,100271,41188,379698,680567,57546,365997,901029,1005900,158052,181124,66444,279216,270565,793412,305826,828473,560370,115672,157012,334764,223687,815502,213985,600590,446641,854795,636604,714412,110045,902722,114640,269475,249951,847429,678992,103291,272334,190145,1015602,266869,851878,714890,454993,889223,993864,764747,827366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]