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` = 302481 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302481 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510658,769085,40393,913072,212083,631741,391752,939257,298975,765016,566918,1024622,719556,336929,140386,124026,728729,740934,865555,472089,203879,993319,601349,888100,517919,980552,98729,845339,809827,976072,200895,261162,641803,633333,779842,661806,363202,991877,982141,138894,311837,544310,117697,111064,338898,45052,188732,520913,970843,731815,415332,169417,663473,112636,425196,513108,581460,432406,939651,947736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]