SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39574 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39574 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374016,910979,799426,82418,723150,979614,406143,107954,291924,744044,1004195,512450,66751,385781,922132,299812,337874,412270,194203,949589,736903,431126,661794,1039999,723940,196023,362085,427907,196470,429230,567982,835051,166671,294444,379395,323198,86103,382408,616613,254782,586024,29014,757208,508161,593950,182882,68891,694968,64779,750452,196970,91849,911441,370937,657099,607470,797404,915474,1047333,60979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]