SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390545 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390545 [ RunTime:0.001224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946117,186488,739302,474642,1024873,143041,922827,934241,945992,875682,989469,431008,575102,22142,966388,3614,298009,350187,209368,1013792,57688,1045823,649488,140780,308432,739129,398134,1021231,524478,2953,190092,490540,584822,500666,653557,426522,263492,74161,784176,676776,553465,354601,206451,910482,283335,918067,742652,732302,872697,262592,367774,958779,688380,816935,585067,49754,469786,310793,147895,647170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]