SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506143 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506143 [ RunTime:0.002585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186792,215850,244092,49392,732942,1034525,527332,853456,873120,245525,742236,1006337,978825,773335,775909,307869,674140,615945,762964,404395,49552,463968,420507,593439,888365,530127,926743,260755,285702,134797,904512,83992,933901,385358,288100,495387,89079,435257,1306,104340,503037,987016,455654,432793,658571,529333,48557,994673,564407,110329,551650,295027,543645,510498,721095,583876,216192,441209,389801,1005904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]