SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527710 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527710 [ RunTime:0.004362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501445,272837,88445,280830,522786,980511,385819,872588,192687,190375,634797,729622,163855,897563,887682,595330,213231,491981,324480,730492,242346,428363,102184,846011,249823,93992,853218,57755,497366,86360,719080,956655,322034,955057,959010,156754,198528,936852,724279,554194,545396,55761,459200,84555,317454,789637,795157,934945,810049,536203,558250,762051,199682,798126,1015536,346340,995189,226601,253483,268106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004478s ]