SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503762 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503762 [ RunTime:0.004858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236333,675820,533807,100900,967930,803378,8512,579592,305566,512002,583673,143808,642372,949030,73364,354063,850424,355170,39603,765612,819164,848307,332095,278873,925983,755359,230908,965001,170091,978705,484892,627166,293911,516919,344125,795483,401770,386153,693270,451963,520770,52018,901100,565337,522669,788808,421922,1005856,908526,1018030,465557,221253,275655,2862,413264,889441,281150,320970,818957,617388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001429s ]