SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4328 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4328 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588704,234544,535009,720308,855948,932570,490650,116575,118234,313871,76150,849463,730497,872151,406482,764667,974274,885073,882271,1043346,903440,350389,527949,418599,36521,772328,332600,592297,975767,928626,342156,974710,854662,860819,421637,715392,270640,337881,457764,910297,247020,928660,990142,19706,468356,173182,194108,950509,1000725,21258,469142,885324,180865,361526,405217,244680,433026,1040892,283410,592527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]