SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348611 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348611 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673978,923982,588096,866707,467882,2110,739003,548917,728561,387666,178838,978443,67188,264758,733820,503770,84987,1015702,624754,184947,290302,365968,166583,926005,91600,433060,364088,448211,387196,483342,738125,742734,794757,494441,102744,881496,703587,827534,416150,471640,926513,864509,686519,463083,726734,491464,756050,122066,741968,565231,611414,673960,359931,627208,732522,310263,806049,25809,548352,764238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]