SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261214 LIMIT 1 [ RunTime:0.001253s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261214 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017418,100389,605136,182520,616541,572122,951600,268214,917353,690327,140604,968017,462773,990637,670862,110324,155423,932979,794230,587045,11097,658883,722646,88714,507119,416328,975146,600933,260071,573651,382299,1031007,2237,93054,1017980,504646,826828,169177,973864,739347,333192,123577,513160,447049,1023337,579996,466179,552909,500434,432296,822258,108917,618951,632424,923755,126091,910844,725484,292808,600176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]