SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025250 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025250 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592847,1036799,211035,62762,783621,182824,833932,855814,1026746,972109,597226,201951,341340,886574,101938,475960,234262,624633,795673,1005787,79118,379871,330836,608575,183654,835006,396234,6808,64359,709539,955078,58318,227807,945959,787011,209411,521616,233068,313449,900327,473061,713430,425939,690792,951225,1043233,196521,889363,569334,425997,112949,830293,752513,293458,82678,50105,335638,681362,719641,1022819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]