SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 948070 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 948070 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897210,929993,947540,10236,540969,162665,748338,1010950,24296,632645,462950,2015,646934,202557,646497,589800,588098,735489,192670,463201,454198,256305,341223,67362,571462,911710,643763,269184,783135,310684,707092,312847,313673,584431,459609,994066,312471,285900,1014470,939862,785360,272324,301669,817870,592895,187429,916929,36026,991907,198550,759318,728432,468096,255105,752700,786328,15842,54613,365085,485460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 948070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 948070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]