SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439843 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439843 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632105,412555,1027099,614377,94423,732613,384071,377509,458471,289410,817376,387679,219186,998586,305517,499797,25182,311704,534186,352304,242070,215445,603017,868322,211025,764963,688010,553911,632453,524319,27933,915825,235785,690837,9759,549249,917390,59894,926848,966913,401069,87790,156463,663763,18309,168226,400442,687718,608505,748296,196875,408293,147091,43900,78709,938090,943025,1016214,940255,236981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]