SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509391 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509391 [ RunTime:0.005165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403579,657551,208870,232726,661170,341525,922920,128737,297508,5306,705240,726866,196048,978927,453546,737955,474782,327851,623106,493875,434251,898167,135762,664720,282069,631658,480099,698124,898368,293925,144077,551689,85384,739198,375272,725861,903509,632421,513313,160500,579085,2834,378126,575983,457521,750068,720445,307840,720724,678447,572761,652658,829922,331453,659219,791533,239320,847352,965078,852590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003476s ]