SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 848021 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 848021 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105001,459531,64831,1039843,948142,585336,379054,828570,130749,139345,977739,1023191,883814,904550,248525,516815,917912,154368,538419,703485,557991,205239,906401,165438,950458,230719,534007,65482,713339,427129,437321,812803,492987,429348,738336,46182,798299,638906,854388,382493,422740,31641,176761,979432,574734,50261,399582,261412,179297,148867,458434,458101,1047089,419327,835171,59182,617158,302004,549674,874263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 848021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 848021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]