SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391063 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391063 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938894,294588,24525,919689,154538,167369,117,965207,891156,465617,93932,161482,237688,535860,992741,865261,873562,587154,598874,93535,484188,250877,425047,788959,302434,227649,859995,951873,301897,734922,215889,625256,747071,864875,8524,596310,954942,207832,430884,754830,728139,502663,256856,686306,927745,711999,953004,387665,422113,313158,234801,225407,1019420,848064,493407,612949,685735,216325,1023163,1020527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]