SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809006 LIMIT 1 [ RunTime:0.000726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809006 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579742,814456,568118,89702,138833,476516,791500,284601,754401,889041,655205,597048,275747,807600,960660,1014927,132881,957426,381699,602033,348038,1012041,643334,44156,84877,227149,946466,341002,320162,642748,994956,102039,495449,194872,314129,865867,841642,434957,824994,515525,921878,409721,800731,597045,653277,1001743,543148,696585,837963,495461,933211,815316,728401,534254,754838,93525,854593,367483,326258,346637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]