SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266018 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266018 [ RunTime:0.004617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77681,458355,550,781057,672125,362417,319941,409399,784847,327487,895055,708764,244125,705420,945652,329237,705825,858237,712577,227591,943662,515919,381581,649738,791788,126629,423930,852898,350066,1013898,396934,865276,913584,515146,705728,307728,691125,673199,354663,596572,691502,1002053,497421,642804,143927,579692,832945,1008369,385316,521778,162036,396649,863251,131312,589348,145669,500170,420449,585672,45512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]