SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501764 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501764 [ RunTime:0.003962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716222,100804,274580,306942,731744,86296,956756,25675,522955,507373,363666,17760,965792,221641,123309,431377,140647,581794,511869,785127,173270,2076,112718,813667,689218,521839,302424,532461,804807,46905,62514,57784,271228,756386,1043090,285834,572358,21833,961502,44928,225096,414753,196924,369155,7774,525090,616492,843202,534574,866256,846213,305305,87322,636142,895404,887465,762692,971264,380369,907256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]