SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50445 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50445 [ RunTime:0.004365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18303,77023,770291,1015056,354156,101928,42654,262947,228922,933539,816911,907801,796988,441784,206677,172980,678274,72778,414333,869138,568121,310488,489367,463858,509930,293783,901584,731463,592998,253689,408603,592147,130026,837350,405599,1018167,994380,55246,172868,266759,905083,580314,279129,428124,96915,590380,1029952,58652,537656,719825,238652,240385,116632,590491,1024613,611237,91057,30065,631105,77163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]