SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535163 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535163 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369210,86665,922168,317488,436528,706029,893089,778202,854043,1017970,707317,1040704,176117,817304,700944,434312,812108,136203,393305,3317,646656,746459,927274,784311,915362,563057,619367,358688,305235,275890,1040411,703259,284564,107512,931205,321570,176109,167969,618867,975992,226981,25550,51181,780507,21439,117074,424627,731190,939370,238273,159302,971251,892859,502180,869985,718666,352090,70640,170279,319729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]