SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268001 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268001 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952725,986846,270869,951306,55865,79719,748279,246800,1011111,547704,1016841,213488,865591,119716,1011222,185874,4567,766879,207812,920973,349804,987681,989135,540352,826722,1028842,334192,1001684,42930,784312,296825,313287,731252,159109,358950,257300,480409,288878,186538,8325,403582,297597,834691,619768,404259,701666,48905,260098,730254,888561,799858,1018170,756904,761341,753887,59098,29759,845456,132851,281231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]