SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516196 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516196 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948772,692131,472658,614544,619352,112133,720157,949401,599818,636705,332102,213028,1027546,116794,824017,1017782,32108,862763,661623,249013,1017949,482422,284560,1395,943176,297124,659390,306121,31346,569551,973693,400575,806346,372888,980962,96298,737224,609965,10388,420093,620690,43206,289155,203156,799969,871304,653411,690828,535871,743103,316299,660066,898749,662243,916480,808111,123334,925248,1047630,843689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001028s ]