SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501335 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501335 [ RunTime:0.002580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147329,26134,817582,457047,240498,350958,524471,535577,122614,169296,795642,551052,1034617,413643,998746,806655,349468,457259,821564,768660,430497,625322,155157,234506,638356,930417,98926,820640,965764,33192,217781,95,826579,883882,16697,232974,10140,395811,1011138,426368,805841,537723,442610,203691,202078,975221,577799,251267,652262,447594,92513,31084,74299,600804,724091,668973,19033,620417,937455,511164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]