SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534549 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534549 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401448,186945,725221,777246,76065,48124,1041974,578122,821112,284795,804386,1002006,813458,700944,114467,401700,850188,975580,109878,381106,769574,578020,47108,149599,738244,275857,457904,15281,289784,700837,576649,902124,880276,208655,18017,685820,585123,326857,1041047,286242,292564,26033,922946,306420,540672,529317,43461,485130,144193,438222,299067,115172,61490,91028,221093,712691,332988,936509,930946,337416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]