SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534263 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534263 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18097,244672,977380,683863,3912,881781,623947,590900,862713,512669,741876,889508,176429,207161,244472,744330,501134,909950,206825,165049,355715,166431,438601,94074,974193,758739,66571,954479,798565,399834,135156,57492,365764,340983,903445,510428,90946,128511,173358,739848,236190,10923,426813,886489,50147,733478,619567,905820,229146,394300,165317,554401,143596,738405,174897,387639,365059,492,885755,12871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]