SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50290 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50290 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356446,923432,337855,72109,305047,430822,931489,345259,685377,60512,460628,379143,343395,74632,234240,419867,478418,648182,637181,495263,512218,964441,672465,1036670,889437,317498,686174,773968,617035,782933,336211,867173,1030220,40165,240313,700901,214399,1010549,553346,449861,1004764,515555,549199,305300,425606,121322,318349,685449,244831,300330,802937,647893,1009351,583835,1030805,280406,479511,204292,821510,837445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001325s ]