SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118140 LIMIT 1 [ RunTime:0.000627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118140 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727473,390109,288858,442281,691042,737387,967949,810526,961974,379336,1006330,243257,408301,176610,50635,814797,453566,252798,772940,264049,133631,1020691,968539,705537,39183,277555,978065,820840,872269,566786,851890,645638,916541,177703,56459,65246,838897,851528,324033,261751,49602,112217,874119,690113,39159,770675,916030,915446,901091,616344,486324,862621,233991,764642,1006253,613617,577357,807633,32511,396236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]