SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330083 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330083 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379653,313088,775690,384541,709771,508983,2795,579723,542346,895858,961832,401664,175430,451950,723108,835069,28531,607251,208910,804909,922503,731048,658872,119505,498628,880651,987197,574407,464894,1039331,283575,48642,836205,273413,301838,89062,529553,919221,227987,662737,395578,286460,225888,747395,742281,558933,903336,78987,611229,816905,924047,889074,872013,88100,543525,671191,590733,357871,20007,269603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]