SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803561 LIMIT 1 [ RunTime:0.002086s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803561 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419260,752229,568882,341695,797979,616034,421766,827008,386513,609316,595771,1046387,921155,729107,472363,1028336,60099,747758,827610,395109,219705,16470,85296,394983,114694,1040877,209359,913903,102882,66791,1001801,900021,220348,589775,959910,811380,997253,464623,766117,1024850,237876,699480,48794,1035623,609534,7567,318429,393519,747806,298156,264447,652824,689106,979511,437770,1045429,584304,528311,809914,95164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]