SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260830 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260830 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344706,423739,1037488,874865,966064,347218,1021784,490292,720229,75364,201463,280723,632971,989834,612076,8213,551167,1014263,804993,731523,634028,386272,654865,176020,218067,107873,409328,184824,171969,482567,483872,377175,760817,825571,869056,752561,889607,327491,736878,263125,72304,352409,949115,882695,703966,201063,783037,473038,152690,627425,476099,146921,855486,460497,450818,655639,382623,779527,833611,87447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]