SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418916 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418916 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195486,642168,777210,843752,89622,352520,286961,259189,543226,158520,531641,403058,608140,465695,645298,850294,130627,135646,614458,476908,683291,631974,601612,985637,136467,280030,593580,304786,522950,685569,458458,813459,889259,535791,891766,223024,1024745,857059,554514,597523,155891,1013303,464104,114001,819370,795332,378642,21714,300349,528046,597066,124244,114149,226670,361178,820720,41498,906005,823959,885268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]