SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040436 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040436 [ RunTime:0.003213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562185,352092,500715,1023096,982798,169753,191378,915557,643064,168100,642476,59237,472830,756401,857031,777642,333649,93882,158468,321181,1033250,870969,439291,493216,483680,173219,518688,488488,419307,160192,694241,873319,834617,719299,981959,566435,248750,727839,776987,739644,178904,597433,79710,6896,50456,990124,186769,491523,775135,54125,1035323,1043729,295426,3012,303845,936476,22226,486726,771586,24603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]