SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228448 LIMIT 1 [ RunTime:0.000728s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228448 [ RunTime:0.003057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268967,931636,974544,290741,739892,171425,286980,484992,281518,179994,308071,641117,637385,709762,441895,895176,387253,466561,275655,380555,781223,1014837,604791,970426,112238,574130,793202,124870,156400,409873,802725,1035944,562743,349791,737994,202632,754605,726710,94057,401042,908056,313649,1019536,457534,901600,1021340,64707,366407,776769,348006,199280,291971,392504,1008619,322151,362871,984573,980698,329767,1006592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]