SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041440 LIMIT 1 [ RunTime:0.001716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041440 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813358,763175,670341,913684,72595,398964,142659,352940,92913,91871,660848,308656,1022147,240430,298565,891213,532600,659534,120448,374279,758107,544817,949920,440194,406613,728946,944501,622196,570965,850035,687757,747316,1008442,365425,199844,534488,562965,122517,688320,79871,300617,649892,459077,485820,572008,929882,313866,441634,594480,91408,374574,722404,800889,674736,177529,612316,450811,396218,511761,707981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]