SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28012 LIMIT 1 [ RunTime:0.002515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28012 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932800,640235,845742,34238,929605,196974,502493,117294,243483,644902,962328,777648,830480,604840,14133,774314,141784,983841,552093,564288,1014180,571940,47066,205927,768874,827314,907798,86871,792602,596163,221975,891433,190366,587022,536429,100624,993017,209104,755383,654396,821776,167790,879446,481052,1028039,40411,953271,392689,837343,475567,721117,492153,873704,315095,929030,773457,445291,651862,694300,17932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]