SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542843 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542843 [ RunTime:0.002798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510815,603209,1017979,137073,395605,166001,355214,760803,372984,1026644,646650,279190,948365,950316,763147,78320,420413,654778,194727,18309,736381,970160,962889,478375,769819,792870,834695,14614,463331,333081,587963,114008,387789,625750,504996,314793,685799,678783,894809,970721,100124,517626,448790,728144,63829,728324,646316,800423,972595,85052,870769,539064,243497,531748,148038,627251,49762,66979,484866,26910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]