SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 156991 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 156991 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696220,418143,481705,1041016,67726,866918,943074,863969,974396,153305,304811,52656,747879,712413,906107,835130,270611,756680,946243,457904,1000280,732631,365182,746270,426212,94486,937568,496441,342439,215395,665728,682228,998344,932934,443832,616635,792451,837275,204251,361084,341641,417577,14211,579843,944907,552004,1020943,32427,707543,752453,818620,215204,854849,433648,594148,964862,747156,666015,465639,246033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 156991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 156991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]