SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520823 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520823 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291441,569974,862262,618680,860485,937892,419390,1048735,899708,15257,136735,83154,732071,184348,196184,802317,843494,433073,255789,662637,911388,312916,173648,1008905,172649,1044366,1009008,1033061,75746,619632,222197,149584,469209,563373,217499,160788,958479,63664,87699,1013644,878060,279074,938337,426624,339751,388329,412448,855921,812377,704209,441934,829099,301460,393800,399096,447927,164761,24791,163424,171681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]