SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319546 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319546 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961194,423883,411940,624783,674790,405535,286037,149447,86673,370491,318238,990308,213042,181175,981048,621684,422089,839630,253754,232159,641430,297471,587318,880789,588301,1047483,941220,893772,759677,450750,1003796,832565,132507,234244,559986,371827,927644,114817,904172,185997,609585,630937,313869,85648,353434,1011907,514794,404392,288687,41276,1013668,1047854,842903,1038703,816325,997364,816415,670977,975580,185204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]