SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241314 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241314 [ RunTime:0.003836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011695,42153,919368,923316,687698,707498,289907,609217,436197,4284,230610,410135,104378,211751,900025,213618,408799,508647,46542,343035,471291,350394,169250,447537,687659,1009358,801438,293902,346358,331564,311621,287705,615679,664237,883276,601609,834144,907925,475168,314478,28612,293640,572526,1005064,57306,466693,726192,148898,834806,94965,424134,451524,537833,651511,775871,226732,960042,521214,83416,403333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]