SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503831 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503831 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431415,894698,828878,668420,271231,170515,166924,702926,359665,934484,29224,770466,855603,350375,907722,547023,86457,702250,962129,252926,968598,326541,434635,769860,834009,199878,732545,881121,923830,957815,136259,843771,30872,230281,894675,775184,680033,685421,667612,802332,833816,930651,871704,994481,658649,693830,574047,258320,342657,498776,550610,784230,359886,588651,85085,904223,171482,123643,396947,42617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]