SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002927s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471610 LIMIT 1 [ RunTime:0.000794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471610 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107946,843991,532357,163447,753904,618180,72256,131219,721397,338478,714584,620322,472721,668482,982974,5060,1026401,454575,989544,835526,595481,428409,274032,329417,562972,713391,70332,496733,345138,690498,543838,55437,365508,164958,350305,167795,996978,672463,677138,158692,276530,50128,291235,449403,553502,475566,833271,580080,443911,530062,60420,1048836,490063,1784,207673,84398,533928,900306,515109,692174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]