SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514476 LIMIT 1 [ RunTime:0.003045s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514476 [ RunTime:0.004487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209949,794117,720302,43257,855728,531268,943371,253108,798549,152273,150936,27675,962582,331553,538802,427670,389671,160017,64206,432231,789780,723238,472046,527513,968258,195910,279114,760430,105888,110797,441123,685123,793549,170163,393283,215850,990742,369994,838872,83167,655307,130260,12198,397496,1011402,843034,95449,424741,27434,1017636,39094,215019,390234,511264,691970,591958,548296,201224,969836,252013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001194s ]