SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105393 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105393 [ RunTime:0.007992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584670,912115,67082,996130,744017,925683,724926,1032984,429593,1024329,900651,330019,869174,795832,424899,979363,842268,785154,355239,784981,241212,398480,1023955,268810,133192,298752,234317,440811,664188,484876,437524,665237,1000822,590968,299277,362625,492898,386851,449790,763646,519818,313400,358767,874748,333386,886555,68844,515027,169435,817577,618279,64384,312645,703885,331545,332583,251400,582599,218832,149904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]