SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261863 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261863 [ RunTime:0.004133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251792,922448,753544,85802,1048753,141171,12394,897852,700003,391426,466922,111144,561854,776691,694068,731392,839348,985945,535291,443373,981542,471638,861944,282003,719569,496358,100253,238201,845402,331882,70018,651994,694119,607982,1000670,822900,855186,491308,328960,467503,322684,16193,242467,622670,724665,657997,18973,293028,448174,270501,436927,685666,26235,271521,34255,486513,799733,815045,742326,177930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001118s ]