SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029705 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029705 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593734,919635,335472,267558,775074,779386,942328,1003799,683670,268956,564598,423526,843042,1027049,650265,550645,580807,121543,426843,517685,124907,127205,520465,497589,999494,491657,732253,975795,287046,577351,371466,251598,717712,252483,727685,924605,686443,432975,251076,321467,322766,261188,551102,986813,711914,682767,593623,551744,850632,817920,433828,19550,144208,102506,182276,328995,369682,165418,778766,105634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002005s ]