SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310239 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310239 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475944,269034,850103,245241,659556,230123,104538,97540,243090,649496,445499,249638,301657,132211,1027072,338894,687943,753836,574017,917773,801916,391773,249431,125921,365179,382956,182605,527643,290023,1046128,401389,284596,614896,227523,217329,796363,262311,539422,579227,114718,936772,216627,409792,14638,712908,154279,168557,368732,98646,267065,491653,159900,667628,1026090,848806,1009886,833462,518917,974869,963180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]