SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044186 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044186 [ RunTime:0.003068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159734,865870,378786,837070,714675,350883,775303,381957,165558,915886,255545,877365,867187,823649,484840,810827,630370,489297,1012020,930982,189344,934774,803075,840817,457561,112234,312817,419386,329987,309936,427957,866675,723963,477951,152545,97634,782333,359482,878162,346686,933880,535140,307504,978839,1025386,41796,167347,154340,897516,23849,697886,43059,712158,585208,168099,812545,652697,734685,785162,906135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001586s ]